<?php
/**
 * Created by PhpStorm.
 * User: Dave
 * Date: 2018/6/29
 * Time: 15:44
 */

ini_set('display_errors', 1);
error_reporting(-1);
require_once '/data/wwwroot/g_vendor/autoload.php';

use Biz\model\GoodsBasicInfo as mGoodsBasicInfo;
use Doraemon\model\PhotoRelaGoods as mPhotoRelaGoods;

$sql = 'select  `wiki_id`  from `goods_basic_info` where four_category_id in(
    129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,
    163,164,165,166,167,168,169,170,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,
    206,207,208,209,210,211,212,213,214,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,
    243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,
    280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,307,311,312,313,314,315,316,317,318,320,323,326,
    327,328,329,330,331,332,334,337,339,340,341,343,344,345,346,347,348,351,352,353,354,355,356,357,358,359,360,361,363
) and `max_price` <=999 ';

$data = mGoodsBasicInfo::query($sql)->fetchAll();

foreach($data as $value){
    $wikiId[] = $value['wiki_id'];
}

$wikiId = implode(',', $wikiId);

$sqlWiki = "select `goods_id`,`other_id` from `photo_rela_goods` where goods_id in({$wikiId}) or other_id in({$wikiId})";
$data = mPhotoRelaGoods::query($sqlWiki)->fetchAll();

foreach($data as $value){
    $goods[] = $value['goods_id'];
    $goods[] = $value['other_id'];
}

$wikiId =implode(',', array_unique($goods));

$sqlCount = "select count(goods_id) as count from `goods_basic_info` WHERE `wiki_id` in  ({$wikiId})";

$dataCount = mGoodsBasicInfo::query($sqlCount)->fetchAll();
var_dump($dataCount);
$sqlGoods = "select goods_id from `goods_basic_info` WHERE `wiki_id` in  ({$wikiId})";

$dataGood = mGoodsBasicInfo::query($sqlGoods)->fetchAll();

foreach($dataGood as $value){
    $dataGoods[] = $value['goods_id'];
}
var_dump(implode(',', $dataGoods));